package com.qf.order.domain.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class OrderExcelDTO {

    @ExcelProperty(value = "订单号", index = 0)
    @ColumnWidth(20)
    private String orderId;

    @ExcelProperty(value = "客户名称", index = 1)
    @ColumnWidth(15)
    private String customerName;

    @ExcelProperty(value = "始发地", index = 2)
    @ColumnWidth(10)
    private String origin;

    @ExcelProperty(value = "目的地", index = 3)
    @ColumnWidth(10)
    private String destination;

    @ExcelProperty(value = "订单状态", index = 4)
    @ColumnWidth(10)
    private String orderStatus;

    @ExcelProperty(value = "运输类型", index = 5)
    @ColumnWidth(10)
    private String transportType;

    @ExcelProperty(value = "货物类型", index = 6)
    @ColumnWidth(10)
    private String goodsType;

    @ExcelProperty(value = "货物总数量", index = 7)
    @ColumnWidth(12)
    private Integer totalQuantity;

    @ExcelProperty(value = "总重量(kg)", index = 8)
    @ColumnWidth(12)
    private BigDecimal totalWeight;

    @ExcelProperty(value = "总体积(m³)", index = 9)
    @ColumnWidth(12)
    private BigDecimal totalVolume;

    @ExcelProperty(value = "运输费(元)", index = 10)
    @ColumnWidth(12)
    private BigDecimal transportFee;

    @ExcelProperty(value = "费用合计(元)", index = 11)
    @ColumnWidth(12)
    private BigDecimal totalCost;

    @ExcelProperty(value = "下单时间", index = 12)
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    @ColumnWidth(20)
    private Date orderTime;
}
